﻿CREATE TABLE [dbo].[datTelefonNotiz] (
    [NotizID]       INT           IDENTITY (1, 1) NOT NULL,
    [NameAnrufer]   NVARCHAR (50) NOT NULL,
    [Firma]         NVARCHAR (50) NULL,
    [TelefonNummer] NVARCHAR (50) NOT NULL,
    [Betreff]       NVARCHAR (50) NOT NULL,
    [Strasse]       NVARCHAR (50) NULL,
    [Plz]           NCHAR (10)    NULL,
    [Ort]           NVARCHAR (50) NULL,
    [EMail]         NVARCHAR (50) NULL,
    [NotizOrgKey]   INT           CONSTRAINT [DF_datTelefonNotiz_NotizOrgKey] DEFAULT ((0)) NULL,
    [AnrufZeit]     DATETIME2 (7) NOT NULL,
    [AnrufType]     INT           NOT NULL,
    [TecUser]       INT           NOT NULL,
    [Status]        TINYINT       CONSTRAINT [DF_datTelefonNotiz_Status] DEFAULT ((0)) NOT NULL,
    [AnlageDatum]   DATETIME2 (7) NOT NULL,
    [Änderung]      DATETIME2 (7) NOT NULL,
    CONSTRAINT [PK_datTelefonNotiz] PRIMARY KEY CLUSTERED ([NotizID] ASC)
);

